|
Showing 1 - 4 of
4 matches in All Departments
Find out what Excel is capable of with this step-by-step guide to
VBA Short of changing the tires on your car, Microsoft Excel can do
pretty much anything. And the possibilities are even more endless
when you learn to program with Excel Visual Basic for Applications
(VBA). Regardless of your familiarity with Excel VBA, Excel VBA
Programming For Dummies can enhance your experience with the
popular spreadsheet software. Pretty soon, you'll be doing things
you didn't think were possible in Excel, from automating processes
to writing your own worksheet functions. You'll learn how to:
Understand the basic tools and operations of Visual Basic for
Applications Create custom spreadsheet functions that make life
easier for you and the people maintaining your spreadsheets Deal
with errors and exceptions and eliminate the bugs in your code
Perfect for anyone who's never even heard of Excel VBA, Excel VBA
Programming For Dummies is also a fantastic resource for
intermediate and advanced Excel users looking for a heads-up on the
latest features and newest functionality of this simple yet
powerful scripting language.
Large corporations like IBM and Oracle are using Excel dashboards
and reports as a Business Intelligence tool, and many other smaller
businesses are looking to these tools in order to cut costs for
budgetary reasons. An effective analyst not only has to have the
technical skills to use Excel in a productive manner but must be
able to synthesize data into a story, and then present that story
in the most impactful way. Microsoft shows its recognition of this
with Excel. In Excel, there is a major focus on business
intelligence and visualization. Data Visualization with Excel
Dashboards and Reports fills the gap between handling data and
synthesizing data into meaningful reports. This title will show
readers how to think about their data in ways other than columns
and rows. Most Excel books do a nice job discussing the individual
functions and tools that can be used to create an "Excel Report".
Titles on Excel charts, Excel pivot tables, and other books that
focus on "Tips and Tricks" are useful in their own right; however
they don't hit the mark for most data analysts. The primary reason
these titles miss the mark is they are too focused on the
mechanical aspects of building a chart, creating a pivot table, or
other functionality. They don't offer these topics in the broader
picture by showing how to present and report data in the most
effective way. What are the most meaningful ways to show trending?
How do you show relationships in data? When is showing variances
more valuable than showing actual data values? How do you deal with
outliers? How do you bucket data in the most meaningful way? How do
you show impossible amounts of data without inundating your
audience? In Data Visualization with Excel Reports and Dashboards,
readers will get answers to all of these questions. Part technical
manual, part analytical guidebook; this title will help Excel users
go from reporting data with simple tables full of dull numbers, to
creating hi-impact reports and dashboards that will wow management
both visually and substantively. This book offers a comprehensive
review of a wide array of technical and analytical concepts that
will help users create meaningful reports and dashboards. After
reading this book, the reader will be able to: Analyze large
amounts of data and report their data in a meaningful way Get
better visibility into data from different perspectives Quickly
slice data into various views on the fly Automate redundant
reporting and analyses Create impressive dashboards and What-If
analyses Understand the fundamentals of effective visualization
Visualize performance comparisons Visualize changes and trends over
time
Save time and become an Excel wizard with the world's leading Excel
macro guide Do you love Excel and all the things you can do with
it, but wish you could just work...faster? Excel macros--automated
workflows that save you time and energy--might be just what you
need. In Excel Macros For Dummies, you'll learn over 70 of the most
productive, time-saving macros in less time than it takes to back
up the files on your computer! Every chapter in the book gives you
practical info and exercises you can put to work immediately,
alongside step-by-step instructions and guidance on how to
customize Excel to fit your every need. Inside, you'll find:
Automations that take your Excel productivity to the next level,
and beyond Fully updated macros compatible with the newest version
of Excel included in Microsoft 365 Careful explanations of the
basics as well as tips for the advanced user With something for
everyone, Excel Macros For Dummies is the productivity supercharger
you've been waiting for. Grab a copy today!
|
You may like...
Loot
Nadine Gordimer
Paperback
(2)
R398
R330
Discovery Miles 3 300
|
Email address subscribed successfully.
A activation email has been sent to you.
Please click the link in that email to activate your subscription.